home *** CD-ROM | disk | FTP | other *** search
/ Power Tools 1993 November - Disc 2 / Power Tools Plus (Disc 2 of 2)(November 1993)(HP).iso / hotlines / gsyhl / dbfeat / ingres.txt < prev    next >
Text File  |  1993-04-02  |  29KB  |  523 lines
  1.            STRATEGIC PROFILE OF THIRD-PARTY RELATIONAL DATABASES
  2.  
  3.                         ------INGRES Ver 6.4-------
  4.  
  5. LANGUAGES SUPPORT
  6. ------------------------------------------------------------------------
  7. Japanese                                     Yes
  8. ------------------------------------------------------------------------
  9. Hanggui                                      Yes; also Korean, Chinese
  10. ------------------------------------------------------------------------
  11. Sorting Sequences                            Yes
  12. ------------------------------------------------------------------------
  13. Error messges                                Yes
  14. ------------------------------------------------------------------------
  15. Upper/Lower case conversion                  Yes
  16. ------------------------------------------------------------------------
  17. Sorting/Collating sequences                  Yes
  18. ------------------------------------------------------------------------
  19. Multiple character set support               Yes
  20. ------------------------------------------------------------------------
  21. 2-Byte character set                         Yes
  22. ------------------------------------------------------------------------
  23.  
  24.  
  25. GRAPHICS PRESENTATION                     Ingres/Graphics VIGRAPH
  26. ------------------------------------------------------------------------
  27. WYSIWYG environment                          Yes
  28. ------------------------------------------------------------------------
  29. Product graphics directly from query         Yes
  30.  
  31.  
  32. CONNECTIVITY/GATEWAYS
  33. ------------------------------------------------------------------------
  34. DB2 Connectivity                            Yes; read-only for IMS
  35. VAX VMS, IMS, Allbase, Oracle, Rdb           No for Oracle
  36. ------------------------------------------------------------------------
  37. PC Integration                               Ingres/PCLINK, PC Ingres,
  38.                                              Ingres,ABF/4GL, Tools
  39.                                              for DOS & Servers for OS/2
  40.                                              Windows3.1, Mac
  41. PORTABILITY
  42. ------------------------------------------------------------------------
  43. ANSI 89 (level 2) compatibility              Yes
  44. ------------------------------------------------------------------------
  45. Hardware Platform Supported                  IBM Mainframe, HP 3000,
  46.                                              HP 9000, DEC VAX, Unix
  47.                                              systems, PCs, Macintosh
  48. ------------------------------------------------------------------------
  49. Operating System Supported                   HP MPX-iX, HP-UX, IBM VM
  50.                                              VAX VMS, Unix, DOS, OS/2,
  51.                                              Windows
  52. ------------------------------------------------------------------------
  53. Support for Non-Relational Database          Yes; via gateways
  54. ------------------------------------------------------------------------
  55.  
  56. DATA TYPES                                   If not supported, can be
  57.                                              built using object mgmt
  58.                                              extension
  59. -------------------------------------------------------------------------
  60. Character                                    Yes
  61. ------------------------------------------------------------------------
  62. Integer                                      Yes
  63. ------------------------------------------------------------------------
  64. Float                                        Yes
  65. ------------------------------------------------------------------------
  66. Logical                                      No
  67. ------------------------------------------------------------------------
  68. Currency                                     Yes
  69. ------------------------------------------------------------------------
  70. Date                                         Yes
  71. ------------------------------------------------------------------------
  72. Time                                         Yes
  73. ------------------------------------------------------------------------
  74. Long Text                                    No
  75. ------------------------------------------------------------------------
  76. Image (BLOBS)                                No; 4GL can handle as
  77.                                              series of binary data type
  78. ------------------------------------------------------------------------
  79. Support for Arrays                           No
  80. ------------------------------------------------------------------------
  81. User defined data type                       Yes
  82. ------------------------------------------------------------------------
  83. User defined functions and operators         Yes
  84. ------------------------------------------------------------------------
  85. Binary (Fixed / Var)                         Yes (2008 bytes max)
  86. ------------------------------------------------------------------------
  87. Sound                                        No
  88. ------------------------------------------------------------------------
  89. Graphics                                     No
  90. ------------------------------------------------------------------------
  91. Facsimiles                                   No
  92.  
  93.  
  94. DISTRIBUTION                                 Ingres/STAR, Ingres/NET
  95. ------------------------------------------------------------------------
  96. Parallel Server                              Yes
  97. ------------------------------------------------------------------------
  98. Location Transparency                        Yes
  99. ------------------------------------------------------------------------
  100. Distributed Query Processing                 Yes
  101. ------------------------------------------------------------------------
  102. Distributed query optimizer                  Yes
  103. ------------------------------------------------------------------------
  104. Distributed transaction processing
  105. (2-phase commit)                             Yes; Ingres database only
  106. ------------------------------------------------------------------------
  107. Support for data replication                 No
  108. ------------------------------------------------------------------------
  109. Access to heterogeneous databases            Yes
  110. ------------------------------------------------------------------------
  111. Loosely coupled support                      Yes
  112. ------------------------------------------------------------------------
  113. Distributed data dictionary                  Yes
  114. ------------------------------------------------------------------------
  115. Max. no. of simultaneously connected dbs     Unlimited
  116.  
  117. ARCHITECTURE
  118. ------------------------------------------------------------------------
  119. Client/Server                                Yes
  120. ------------------------------------------------------------------------
  121. Multiserver                                  Yes
  122. ------------------------------------------------------------------------
  123. Maximum number of server/systems             No limit
  124. ------------------------------------------------------------------------
  125. Maximum number of user/server                Platform dependent
  126. ------------------------------------------------------------------------
  127. Maxiumu number of user/system                No limit
  128. ------------------------------------------------------------------------
  129. Multithreaded server                         Yes
  130. ------------------------------------------------------------------------
  131. Support for symmetric multiprocessors        Yes
  132. ------------------------------------------------------------------------
  133. Open architecture (APIs available)           Yes; call level interface/
  134.                                              embedded SQL
  135. ------------------------------------------------------------------------
  136. Loosely coupled support                      Yes
  137. ------------------------------------------------------------------------
  138.  
  139.  
  140. UNDERLYING FILE STRUCTURE                    Unix; users raw i/o for
  141.                                              log files
  142. ------------------------------------------------------------------------
  143. DATABASE PARAMETERS
  144. -------------------------------------------------------------------------
  145. Database size                                No limit
  146. ------------------------------------------------------------------------
  147. Database/server                              No limit
  148. ------------------------------------------------------------------------
  149. Tables/database                              No limit
  150. ------------------------------------------------------------------------
  151. Records/database                             No limit
  152. ------------------------------------------------------------------------
  153. Record size                                  2K
  154. ------------------------------------------------------------------------
  155. Fields/record                                300
  156. ------------------------------------------------------------------------
  157. Indexes/database                             No limit
  158. ------------------------------------------------------------------------
  159. Database connected to a client               No limit with multisession
  160.                                              connected
  161. ------------------------------------------------------------------------
  162.  
  163. USER INTERFACE                               Menu-driven
  164. ------------------------------------------------------------------------
  165. Menu bypass                                  Yes
  166. ------------------------------------------------------------------------
  167. Contextual help                              Yes
  168. ------------------------------------------------------------------------
  169. Tutorial                                     Yes
  170. ------------------------------------------------------------------------
  171. Ability to customize standard menus          No
  172. ------------------------------------------------------------------------
  173. Support for colors                           Yes
  174. ------------------------------------------------------------------------
  175. Support for graphical user interface         Yes; X-Windows, Windows 4GL,
  176.                                              DEC Windows, OSF/Motif
  177. ------------------------------------------------------------------------
  178.  
  179.  
  180. SCREEN FORMS                                 Windows 4GL, Ingres/ Vision
  181.                                              Visual Forms Editory
  182. ------------------------------------------------------------------------
  183. Default form generator                       Yes
  184. ------------------------------------------------------------------------
  185. Customized                                   Yes
  186. ------------------------------------------------------------------------
  187. Multiple tables/forms                        Yes
  188. ------------------------------------------------------------------------
  189. Multiple screens/forms                       Yes
  190. ------------------------------------------------------------------------
  191. Embedded processing (if-then-else, display   Yes
  192.                     aggregates)
  193. ------------------------------------------------------------------------
  194.  
  195.  
  196. FIELD ATTRIBUTES ON FORMS
  197. ------------------------------------------------------------------------
  198. Case conversion                              Yes
  199. ------------------------------------------------------------------------
  200. Default Value                                Yes
  201. ------------------------------------------------------------------------
  202. Required field                               Yes
  203. ------------------------------------------------------------------------
  204. Acceptable values                            Yes
  205. ------------------------------------------------------------------------
  206. Verification (enter data twice)              No; yes in 4GL
  207. ------------------------------------------------------------------------
  208. Formatting of data                           No; yes in 4GL
  209. ------------------------------------------------------------------------
  210. Calculated fields                            No; yes in 4GL
  211. ------------------------------------------------------------------------
  212. Display/read only (no entry/update)          Yes
  213. ------------------------------------------------------------------------
  214. Hidden                                       Yes
  215. ------------------------------------------------------------------------
  216. Prompt (for data entry)                      Yes
  217. ------------------------------------------------------------------------
  218. Customized help                              Yes
  219. ------------------------------------------------------------------------
  220. Video display                                Yes
  221. ------------------------------------------------------------------------
  222. Ability to change field attribute            Yes
  223.      dynamically
  224. ------------------------------------------------------------------------
  225.  
  226.  
  227. QUERY-BY-FORMS                               QBF, Windows/4GL, Ingres/
  228.                                              Vision
  229. ------------------------------------------------------------------------
  230. Exact match                                  Yes
  231. ------------------------------------------------------------------------
  232. Relational operators                         Yes
  233. ------------------------------------------------------------------------
  234. List of values                               Yes
  235. ------------------------------------------------------------------------
  236. Wild cards                                   Yes
  237. ------------------------------------------------------------------------
  238. Maximum/Minimum values                       Yes
  239. ------------------------------------------------------------------------
  240. Print query results                          No; use print screen
  241. ------------------------------------------------------------------------
  242. Pass results to report writer                No
  243. ------------------------------------------------------------------------
  244. Text search                                  Yes
  245. ------------------------------------------------------------------------
  246.  
  247.  
  248. SQL
  249. ------------------------------------------------------------------------
  250. Standard SQL statements                      Yes
  251. ------------------------------------------------------------------------
  252. Data Definition language (DDL)               Yes
  253. ------------------------------------------------------------------------
  254. Data manipulation language (DML)             Yes
  255. ------------------------------------------------------------------------
  256. Extension to SQL                             Yes
  257. ------------------------------------------------------------------------
  258. Commit/rollback transaction                  Yes
  259. ------------------------------------------------------------------------
  260. Execute operating systems commands           Yes
  261. ------------------------------------------------------------------------
  262. Load/unload data to/from ASCII file          Yes
  263. ------------------------------------------------------------------------
  264. Additional data definition statements        Yes (no alter table)
  265. ------------------------------------------------------------------------
  266. Control-of-flow logic                        Yes
  267. ------------------------------------------------------------------------
  268. Support for embedded SQL                     Yes; Ada, C, Cobol,
  269.                                              Fortran, (Pascal, Basic,
  270.                                              PL/1 not on HP)
  271. ------------------------------------------------------------------------
  272. Suport for dynamic SQL                       Yes
  273. ------------------------------------------------------------------------
  274. Can create new tables with query results     Yes
  275. ------------------------------------------------------------------------
  276. Stored queries                               Yes
  277. ------------------------------------------------------------------------
  278. CASE-insensitive (eg., filed names)          Yes
  279. ------------------------------------------------------------------------
  280. Can call C routines                          Yes
  281. ------------------------------------------------------------------------
  282. How create SQL queries/statements            Interactive query editor
  283. ------------------------------------------------------------------------
  284. Query optimizer-statistical                  Yes
  285. ------------------------------------------------------------------------
  286. Syntax independent performance               Yes
  287. ------------------------------------------------------------------------
  288. Optimization method                          Cost-based
  289. ------------------------------------------------------------------------
  290. Procedural extension to SQL                  Yes
  291. ------------------------------------------------------------------------
  292. Remote SQL database calls                    Yes
  293. ------------------------------------------------------------------------
  294.  
  295.  
  296. B-TREE INDEXING
  297. -------------------------------------------------------------------------
  298. Maximum number of indexes                    No limit
  299. ------------------------------------------------------------------------
  300. Maximum number of fields/index               256
  301. ------------------------------------------------------------------------
  302. Maximum size of index key                    400 bytes
  303. ------------------------------------------------------------------------
  304. Order options                                Ascend/Descend
  305. ------------------------------------------------------------------------
  306. Unique index                                 Yes
  307. ------------------------------------------------------------------------
  308. Clustered index                              Yes
  309. ------------------------------------------------------------------------
  310. Other file access methods (hash, etc.)       Heap, ISAM, Sorted Heap
  311. ------------------------------------------------------------------------
  312.  
  313.  
  314. REPORT WRITER                                Report-By-Forms
  315. ------------------------------------------------------------------------
  316. Non Procedural                               Yes
  317. ------------------------------------------------------------------------
  318. Default report generator                     Yes
  319. ------------------------------------------------------------------------
  320. Interactive report generator                 Yes
  321.      using screen forms
  322. ------------------------------------------------------------------------
  323. Interactive debugging                        No
  324. ------------------------------------------------------------------------
  325. Input source                                 SQL/QUEL
  326. ------------------------------------------------------------------------
  327. Multiple tables                              Yes
  328. ------------------------------------------------------------------------
  329. Page formatting                              Yes
  330. ------------------------------------------------------------------------
  331. Headers and footers                          Yes
  332. ------------------------------------------------------------------------
  333. Data formatting                              Yes
  334. ------------------------------------------------------------------------
  335. Sort data                                    Yes
  336. ------------------------------------------------------------------------
  337. Aggregate functions                          Yes
  338. ------------------------------------------------------------------------
  339. Logical processing (if-then logic)           Yes
  340. ------------------------------------------------------------------------
  341. User variables                               Yes
  342. ------------------------------------------------------------------------
  343. Prompt for input variables at run time       Yes
  344. ------------------------------------------------------------------------
  345.  
  346.  
  347. APPLICATION GENERATOR                        Ingres 4GL, Windows 4GL,
  348.                                              ABF
  349. ------------------------------------------------------------------------
  350. CASE Tools                                   Windows 4GL, CADRE
  351. ------------------------------------------------------------------------
  352. 4GL Interface                                Yes; Ingres/Windows 4GL
  353. ------------------------------------------------------------------------
  354. Ability to design application menus          Yes
  355. ------------------------------------------------------------------------
  356. Default menu generator                       Yes
  357. ------------------------------------------------------------------------
  358. Custom help                                  Yes
  359. ------------------------------------------------------------------------
  360. Consistent module interface                  Yes
  361. ------------------------------------------------------------------------
  362. Toolset for multimedia application           No
  363. ------------------------------------------------------------------------
  364.  
  365. ABILITY TO CREATE VIEWS                      Yes
  366. ---------------------------------------------------------------------------
  367.  
  368.  
  369. INTEGRITY                                    Yes
  370. --------------------------------------------------------------------------
  371. Transaction logging                          Yes
  372. ------------------------------------------------------------------------
  373. Commit/rollback transaction                  Yes
  374. ------------------------------------------------------------------------
  375. Roll forward                                 Yes
  376. ------------------------------------------------------------------------
  377. Referential integrity                        Yes; with optional knowledge
  378.                                              management extension; done
  379.                                              via rule (declarative)
  380. ------------------------------------------------------------------------
  381. Field validation                             Yes; on a form via rules
  382. ------------------------------------------------------------------------
  383. Support for business rules                   Yes
  384. ------------------------------------------------------------------------
  385. Database Triggers                            Yes
  386. ------------------------------------------------------------------------
  387. Database event alerters
  388. ------------------------------------------------------------------------
  389. Entity integrity                             Yes
  390. ------------------------------------------------------------------------
  391. Domain Integrity                             Yes
  392. ------------------------------------------------------------------------
  393.  
  394.  
  395. STORED PROCEDURES                            Business Rules in RDBMS
  396. ------------------------------------------------------------------------
  397. Precompiled                                  Yes
  398. ------------------------------------------------------------------------
  399. Can be nested                                Yes
  400. ------------------------------------------------------------------------
  401. Ability to store and execute                 Yes
  402.      procedures on the server
  403. ------------------------------------------------------------------------
  404.  
  405.  
  406. CONCURRENCY CONTROL LOCKING LEVELS
  407. ------------------------------------------------------------------------
  408. Database                                     Yes
  409. ------------------------------------------------------------------------
  410. Table                                        Yes
  411. ------------------------------------------------------------------------
  412. Record (row)                                 No
  413. ------------------------------------------------------------------------
  414. Page                                         Yes; default
  415. ------------------------------------------------------------------------
  416. Lock type:  shared, update, exclusive        Shared, exclusive, no lock
  417. ------------------------------------------------------------------------
  418. Deadlock recognition                         Yes
  419. ------------------------------------------------------------------------
  420. Other data isolation levels                  No lock, repeatable read
  421.  
  422.  
  423. DATABASE SECURITY
  424. ------------------------------------------------------------------------
  425. Login password                               No
  426. ------------------------------------------------------------------------
  427. Multilevel access control                    Yes
  428. ------------------------------------------------------------------------
  429.      User                                    Yes
  430. ------------------------------------------------------------------------
  431.      Group                                   Yes
  432. ------------------------------------------------------------------------
  433.      Application                             Yes
  434. ------------------------------------------------------------------------
  435. Database-level access                        Yes
  436. ------------------------------------------------------------------------
  437. Table-level access                           Yes
  438. ------------------------------------------------------------------------
  439. Record-level access                          Yes
  440. ------------------------------------------------------------------------
  441. Field-level access                           Yes
  442. ------------------------------------------------------------------------
  443. Access by time of day                        Yes
  444. ------------------------------------------------------------------------
  445. Access by location (workstation)             No; yes with QUEL
  446. ------------------------------------------------------------------------
  447. Ability to define resource limits on user    Yes
  448.      queries (same as create views?)
  449. ------------------------------------------------------------------------
  450.  
  451.  
  452. AVAILABILITY
  453. ------------------------------------------------------------------------
  454. On-line backup                               Yes
  455. ------------------------------------------------------------------------
  456. On-line database changes                     Yes
  457. ------------------------------------------------------------------------
  458. Software-based disk mirroring                No
  459. ------------------------------------------------------------------------
  460.  
  461. Raw Input-Output                             No, except for raw log file
  462. ------------------------------------------------------------------------
  463.  
  464. Database can scan multiple physical          Yes
  465.      devices (disks)
  466. ------------------------------------------------------------------------
  467.  
  468. Support for CD-ROM, WORM Drives              No; not recommended
  469. ------------------------------------------------------------------------
  470.  
  471.  
  472. NETWORK SUPPORT                              TCP/IP, NetBIOS, DECNet
  473.                                              Novell's, SPX/IPX, LUO,
  474.                                              OSI, Banyan Vines, asynch
  475. ------------------------------------------------------------------------
  476.  
  477.  
  478. IMPORT / EXPORT CAPABILITY
  479. ------------------------------------------------------------------------
  480. Import formats                               ASCII delimited, fixed field
  481. ------------------------------------------------------------------------
  482. Export formats                               ASCII delimited, fixed field
  483. ------------------------------------------------------------------------
  484.  
  485.  
  486. DATABASE ADMINISTRATION
  487. ------------------------------------------------------------------------
  488. Screen based administrative utilities        Yes
  489. ------------------------------------------------------------------------
  490. Performance tuning                           Yes
  491. ------------------------------------------------------------------------
  492. Dynamic modification                         Yes
  493. ------------------------------------------------------------------------
  494. Dynamic disk space allocation                Yes
  495. ------------------------------------------------------------------------
  496.  
  497.  
  498. I/O REDUCTION TECHNIQUES
  499. ------------------------------------------------------------------------
  500. Fast Commit                                  Yes
  501. ------------------------------------------------------------------------
  502. Group Commit                                 Yes
  503. ------------------------------------------------------------------------
  504. Parallel Checkpoint on multiprocessor        Yes
  505.      systems
  506. ------------------------------------------------------------------------
  507. Index compression                            Yes
  508. ------------------------------------------------------------------------
  509. Data compression                             Yes
  510. ------------------------------------------------------------------------
  511. Multiblock Read/Write                        Yes
  512. ------------------------------------------------------------------------
  513.  
  514.  
  515. FAULT-TOLERANCE
  516. ------------------------------------------------------------------------
  517. Mirrored Discs                               No
  518. ------------------------------------------------------------------------
  519. Disc Failures                                No
  520. ------------------------------------------------------------------------
  521. CPU Failures                                 No
  522. ------------------------------------------------------------------------
  523.